{\rtf1\ansi\ansicpg1252\cocoartf1138\cocoasubrtf510
{\fonttbl\f0\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;}
{\*\listtable{\list\listtemplateid1\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\*\levelmarker \{hyphen\}}{\leveltext\leveltemplateid1\'01\uc0\u8259 ;}{\levelnumbers;}\fi-360\li720\lin720 }{\listname ;}\listid1}
{\list\listtemplateid2\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\*\levelmarker \{hyphen\}}{\leveltext\leveltemplateid101\'01\uc0\u8259 ;}{\levelnumbers;}\fi-360\li720\lin720 }{\listname ;}\listid2}
{\list\listtemplateid3\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\*\levelmarker \{hyphen\}}{\leveltext\leveltemplateid201\'01\uc0\u8259 ;}{\levelnumbers;}\fi-360\li720\lin720 }{\listname ;}\listid3}
{\list\listtemplateid4\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\*\levelmarker \{hyphen\}}{\leveltext\leveltemplateid301\'01\uc0\u8259 ;}{\levelnumbers;}\fi-360\li720\lin720 }{\listname ;}\listid4}
{\list\listtemplateid5\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\*\levelmarker \{hyphen\}}{\leveltext\leveltemplateid401\'01\uc0\u8259 ;}{\levelnumbers;}\fi-360\li720\lin720 }{\listname ;}\listid5}}
{\*\listoverridetable{\listoverride\listid1\listoverridecount0\ls1}{\listoverride\listid2\listoverridecount0\ls2}{\listoverride\listid3\listoverridecount0\ls3}{\listoverride\listid4\listoverridecount0\ls4}{\listoverride\listid5\listoverridecount0\ls5}}
\paperw11900\paperh16840\margl1440\margr1440\vieww10800\viewh8400\viewkind0
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural

\f0\fs24 \cf0 DATABASE STRUCTURE (DEVELOPING):\
\
user\
\pard\tx220\tx720\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\li720\fi-720\pardirnatural
\ls1\ilvl0\cf0 {\listtext	\uc0\u8259 	}user_id\
{\listtext	\uc0\u8259 	}nickname\
{\listtext	\uc0\u8259 	}password (hash of the salted password)\
{\listtext	\uc0\u8259 	}salt\
{\listtext	\uc0\u8259 	}gender (0: female, 1:male)\
{\listtext	\uc0\u8259 	}monstertype (0:normal, 1:werewolf, 2:vampire, 3:ghost)\
{\listtext	\uc0\u8259 	}spriteset (the name of the spriteset file)\
{\listtext	\uc0\u8259 	}spritenum (the position of the top-left image of the sprite)\
{\listtext	\uc0\u8259 	}level\
{\listtext	\uc0\u8259 	}experience\
{\listtext	\uc0\u8259 	}money\
{\listtext	\uc0\u8259 	}healt\
{\listtext	\uc0\u8259 	}healt_max\
{\listtext	\uc0\u8259 	}magicpw\
{\listtext	\uc0\u8259 	}magicpw_max\
{\listtext	\uc0\u8259 	}schoolreport_id\
{\listtext	\uc0\u8259 	}personalroom_id\
{\listtext	\uc0\u8259 	}map_id\
{\listtext	\uc0\u8259 	}map_pos (code convention x:y in tile units)\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural
\cf0 \
schoolreport\
\pard\tx220\tx720\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\li720\fi-720\pardirnatural
\ls2\ilvl0\cf0 {\listtext	\uc0\u8259 	}schoolreport_id (PK)\
{\listtext	\uc0\u8259 	}user_id (U)\
{\listtext	\uc0\u8259 	}dada\
{\listtext	\uc0\u8259 	}potions\
{\listtext	\uc0\u8259 	}transfiguration\
{\listtext	\uc0\u8259 	}charms\
{\listtext	\uc0\u8259 	}comc\
{\listtext	\uc0\u8259 	}arithmancy\
{\listtext	\uc0\u8259 	}ancientrunes\
{\listtext	\uc0\u8259 	}hom\
{\listtext	\uc0\u8259 	}divination\
{\listtext	\uc0\u8259 	}herbology\
{\listtext	\uc0\u8259 	}mugglestudies\
{\listtext	\uc0\u8259 	}flying\
{\listtext	\uc0\u8259 	}astronomy\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural
\cf0 \
map\
\pard\tx220\tx720\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\li720\fi-720\pardirnatural
\ls3\ilvl0\cf0 {\listtext	\uc0\u8259 	}map_id\
{\listtext	\uc0\u8259 	}socketadd (the udp socket working that map)\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural
\cf0 \
personalroom\
\
\pard\tx220\tx720\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\li720\fi-720\pardirnatural
\ls4\ilvl0\cf0 {\listtext	\uc0\u8259 	}personalroom_id\
{\listtext	\uc0\u8259 	}maphash\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural
\cf0 \
persistentcharm\
\pard\tx220\tx720\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\li720\fi-720\pardirnatural
\ls5\ilvl0\cf0 {\listtext	\uc0\u8259 	}persistent_id\
{\listtext	\uc0\u8259 	}user_id\
{\listtext	\uc0\u8259 	}map_id\
{\listtext	\uc0\u8259 	}map_pos\
{\listtext	\uc0\u8259 	}level\
{\listtext	\uc0\u8259 	}schoolrep_val\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural
\cf0 \
\
}